--Api 表
/*
select * from SYS_Apis
select * from SYS_ApiM --M  Memo Main Manage
ReturnType
返回类型（类似返回值）
1 execSql 
2 openSql
3 execProc(不带返回结果) 
4 openProc(带返回结果集)
5 getList (使用getList sql 模板)
6 执行updata,delete 等，返回 操作的行数
*/

declare 
  @ApiName varchar(50)='pub.curPart',
  @ReturnType int =51
--
--
delete from SYS_Apis where apiName=@ApiName
delete from SYS_ApiM where apiName=@ApiName
insert into SYS_ApiM([apiName],[name],[memo])
select @ApiName,'获取当前组成部分信息','获取当前组成部分信息'
insert into SYS_Apis(ApiName,paramsLen,params,ReturnType,sqlText)
select @ApiName,0,
'',
@ReturnType,
'select a.zcbfid,a.dbname,a.zcbfName,a.sjxmbh,a.stack_status as zcbfState,a.sjnd,a.pzcbfid,b.SerProjectID as projectID,b.sjxmmc as projectName,b.projectState
from sjxm_zcbf a inner join ProjectInfo b on a.sjxmbh=b.sjxmbh
where a.zcbfid=#para(zcbfid)'
